
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<%@ page import="java.io.* ,java.util.*, java.sql.*, Login.*"%>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>:: Shanti Chakra Foundation ::</title>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<script language = "javascript">
  
 	
	function getXMLObject()  //XML OBJECT
            {
                var xmlHttp = false;
                try {
                    xmlHttp = new ActiveXObject("Msxml2.XMLHTTP")  // For Old Microsoft Browsers
                }
                catch (e) {
                    try {
                        xmlHttp = new ActiveXObject("Microsoft.XMLHTTP")  // For Microsoft IE 6.0+
                    }
                    catch (e2) {
                        xmlHttp = false   // No Browser accepts the XMLHTTP Object then false
                    }
                }
                if (!xmlHttp && typeof XMLHttpRequest != 'undefined') {
                    xmlHttp = new XMLHttpRequest();        //For Mozilla, Opera Browsers
                }
                return xmlHttp;  // Mandatory Statement returning the ajax object created
            }
	
//pending work	
	function arrangename()
	{ 	
		var nclick = document.getElementById("fullname");
		alert ("well clicked"+nclick);
		        if(xmlhttp) {
                    xmlhttp.open("GET","AJAXGetDistricts?state=" +d,true);
                    xmlhttp.onreadystatechange  = responsefunction;
                    xmlhttp.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');
                    xmlhttp.send(null);
                }
	
	}
	
</script>

<body >
<p>
<a href="AdminAccount.jsp"> Back</a>
<%
int count = 0;
MySqlConnector ms = new MySqlConnector();
PreparedStatement stmt1;
ResultSet rs1 ;
ms.Connect();
// All members
String q = " SELECT memberid , name, surname, sex, mobile, email  FROM registration order by name  ;" ;
stmt1 = ms.Connect().prepareStatement(q);
rs1 = stmt1.executeQuery();
%>
</p>

<table width="679" border="1" align="left"  bordercolor="#FFFFFF" class="greenlink_no_left_padding">
    <tr>
      <td height="33" colspan="8" bgcolor="#D8F2C9" class="style4"><h1>Members List. </h1></td>
    </tr>
    <tr>
      <td height="28" colspan="2" bgcolor="#FFFF99" class="greenlink_no_left_padding"><p align="center" class="style5"> 
    <input type="submit" name="auser" id="auser" value="Active Members " style="color:#000000; font-weight:bold;" onClick="location = 'ActiveMembers.jsp';">
      </p></td>
      <td height="28" bgcolor="#FFFFFF" class="greenlink_no_left_padding">&nbsp;</td>
      <td height="28" colspan="2" bgcolor="#FFFF99" class="greenlink_no_left_padding"><p align="center" class="style5">
        <input type="submit" name="auser2" id="auser2" value="InActive Members" style="color:#000000; font-weight:bold;" onClick="location = 'ListMembers.jsp';">
      </p></td>
    </tr>
    <tr>
      
      <td class="redtext">Member ID </td>
      <td class="redtext" >Full Name</td>
      <td class="redtext">Gender</td>
      <td class="redtext">Mobile</td>
      <td class="redtext">Mail ID </td>
    </tr>
<% 
 while(rs1.next()==true)
{  
%>
    <tr>
      
      <td width="84" class="boldtext"><%=rs1.getString(1)%> &nbsp;</td>
      <td width="187" class="boldtext"><%=rs1.getString(2)%>. <%=rs1.getString(3)%> </td>
      <td width="73" class="boldtext"><%=rs1.getString(4)%></td>
      <td width="105" class="boldtext"><%=rs1.getString(5)%></td>
      <td width="196" class="boldtext"><%=rs1.getString(6)%></td>
    </tr>
    <% count = count + 1 ;   
}%>
    <tr align="right">
      <td height="22" colspan="6" bgcolor="#D8F2C9" ><div align="right"><span class="redtext">Total (<%=count%>)&nbsp;</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </div></td>
    </tr>
</table>
</body>
</html>